Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# CEIL

Syntax

Description of the illustration ceil.gif

Purpose

`CEIL` returns smallest integer greater than or equal to `n`.

This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. The function returns the same datatype as the numeric datatype of the argument.

See Also: Table 2-10, "Implicit Type Conversion Matrix" for more information on implicit conversion

Examples

The following example returns the smallest integer greater than or equal to the order total of a specified order:

    SELECT order_total, CEIL(order_total) FROM orders
       WHERE order_id = 2434;

    ORDER_TOTAL CEIL(ORDER_TOTAL)
    ----------- -----------------
       268651.8            268652